Interview Questions and Answer
Options:
a. Online analytical processing
b. Online analysis processing
c. Online transaction processing
Reveal Answer
Options:
a. Delivers online analytical processing (OLAP)
b. Delivers data mining functionality
c. Used for extracting and storing data which allows easier reporting
d. Both a and b
Reveal Answer
Options:
a. Analyze very large amount of data
b. Multidimensional data model
c. Analyze very small amount of data
d. None of these
Reveal Answer
Options:
a. Fact Tables
b. Dimension Tables
c. Dimension
d. Measures
Reveal Answer
Options:
a. Fact Table
b. Dimension table
c. Both the above
d. None of these
Reveal Answer
Options:
a. Star Schema
b. Snow Flake Schema
c. Star Flake Schema
d. None of these
Reveal Answer
Options:
a. Each dimension is represented by one dimension table
b. Each dimension table is linked to a fact table
c. The dimension may be represented by more than one Dimension table
d. Not All dimension tables are directly linked to Fact table
Reveal Answer
Options:
a. Each dimension is represented by one dimension table
b. Each dimension table is linked to a fact table
c. Dimension may be represented by more than one Dimension table
d. Not All dimension tables are directly linked to Fact table
Reveal Answer
Options:
a. OLAP
b. OLTP
c. OLAP and OLTP
d. Operational databases
Reveal Answer
Bestdotnet google plus